UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+xORRi/wKXZyARah3Ypk6kAiEShOyhcHOZX+0Gz+7+s='
WHERE
key_id = '1cd425c9d5dcf658422e089b21e157e432902ed8afedc774088f6b26e2b4ff03'
AND (
token = '+xORRi/wKXZyARah3Ypk6kAiEShOyhcHOZX+0Gz+7+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)