UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJULFvabtj9dQSI8CLL17zlcMF0GDyOWwm9LjWFOJs8='
WHERE
key_id = '6f18554a3e019dd8dcd12cc24b99f5fa1dedc0dca252905a19ebae35884aaa19'
AND (
token = 'CJULFvabtj9dQSI8CLL17zlcMF0GDyOWwm9LjWFOJs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)