UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fI1oRdOeHWQgZ+H1f24stRKKXgb+gxgQcesus6wcNos='
WHERE
key_id = 'bc07a0f07bce16bee7781682b4d15818a3ba06d56698172de473c091c1d13073'
AND (
token = 'fI1oRdOeHWQgZ+H1f24stRKKXgb+gxgQcesus6wcNos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)