UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KaQMo/BWYbkGLreKLGLdPIN99S+IRvqzGso4j2UPiu0='
WHERE
key_id = 'a8cecc9eea8d97c5ddbfafef7fc37b9e1a3594dc74603a54c92ad72c4ebe227e'
AND (
token = 'KaQMo/BWYbkGLreKLGLdPIN99S+IRvqzGso4j2UPiu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)