UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZGg1wxg1aa6pl5taW+/5jacpSso9gFQDJuQP4ISV4E='
WHERE
key_id = 'e180185178f7f55926b430af26a993ff8b16f9c6e67352eaa61ad70fe9ac07d1'
AND (
token = 'CZGg1wxg1aa6pl5taW+/5jacpSso9gFQDJuQP4ISV4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)