UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DE6G8xHgXdwhGFiHxRTRT9DwkJavbbmGMmBia58OPEE='
WHERE
key_id = '99113d1c169f616ca660a1dff114f6f4c3e3a4c65ab572de405f4114afe173c2'
AND (
token = 'DE6G8xHgXdwhGFiHxRTRT9DwkJavbbmGMmBia58OPEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)