UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qT1mYmEIbS5+SfWaagx1qmYO6qozYPVQD5yBCQu4GNA='
WHERE
key_id = '1e11efe15f96d8b1a80304852963993f7f299a6b16becdbd80299deff6d86425'
AND (
token = 'qT1mYmEIbS5+SfWaagx1qmYO6qozYPVQD5yBCQu4GNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)