UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCUc7YUXLUwVsj0ChOKzfegCnS/m7lxQI9+uI9+j01I='
WHERE
key_id = 'ae7afdad1e3ec7c5af743c395ac004c073f4601cd6c20713d43a42b7e6372764'
AND (
token = 'lCUc7YUXLUwVsj0ChOKzfegCnS/m7lxQI9+uI9+j01I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)