UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g7TqR2OeBdDyKQliXWNRVUNOSTlxxdMyco1ONvgKhM8='
WHERE
key_id = '3afc8c53aba5f65c77e1a7af6443f680827f4a3c55a0454caa0f82a180867f46'
AND (
token = 'g7TqR2OeBdDyKQliXWNRVUNOSTlxxdMyco1ONvgKhM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)