UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CIszEPVRk6BRzmgQsiwUbIz3vPfOe1/iR/26We2209E='
WHERE
key_id = 'ceee2631c7982afb5c4895f455a8987bbb0f6e01a0a2f92ab1c9e62d5c2ce08d'
AND (
token = 'CIszEPVRk6BRzmgQsiwUbIz3vPfOe1/iR/26We2209E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)