UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2USjcyMCpmnZpTzrMWq9hEC/IC96Y2nzThPbK5OLk2E='
WHERE
key_id = '477c07a35df4718b0eccce5f4ea1685787328b1318058ccf41cb0b3834c15d06'
AND (
token = '2USjcyMCpmnZpTzrMWq9hEC/IC96Y2nzThPbK5OLk2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)