UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2u6oruArg8O3yknaNzkorNnVRauxIYtaTN6Rsonc/d8='
WHERE
key_id = 'bea1278b0c265345d0b62cf05ef00c2d97cdca551ab3ad6c9554065e867bd3ac'
AND (
token = '2u6oruArg8O3yknaNzkorNnVRauxIYtaTN6Rsonc/d8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)