UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/2FvLwvqpwpY9z4R6x4uWjQ3DfU6lvGG3ub856Urr00='
WHERE
key_id = '5ce3d1b8a5417d8a3ef511fe0b0be377a14988cd92a25b98acc8b85afd33a497'
AND (
token = '/2FvLwvqpwpY9z4R6x4uWjQ3DfU6lvGG3ub856Urr00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)