UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fX1gTzEkCaZRwnB1n6iFitimUAz7bbG5aFv2s28u0pg='
WHERE
key_id = 'd349e70c578851d7fda07320f14b87c03f7666f9be706f955f9082728f5e65c1'
AND (
token = 'fX1gTzEkCaZRwnB1n6iFitimUAz7bbG5aFv2s28u0pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)