UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HA9HZaE7U/xT3k8AA9zoGyvPKU3JFNo+clyVE55u7W4='
WHERE
key_id = '93ba9537f116b2fe44cb96f89794de3a74374150a490c357dc58385911e6cc68'
AND (
token = 'HA9HZaE7U/xT3k8AA9zoGyvPKU3JFNo+clyVE55u7W4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)