UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDZS5JC6mQJgNK2lCJAw2Jz9sv3rtqDnaC8o1FqGR9Q='
WHERE
key_id = '6a08dab5da6e4facebf980580fdc53efa045fb8cec3617951f048e2badc07ecf'
AND (
token = 'XDZS5JC6mQJgNK2lCJAw2Jz9sv3rtqDnaC8o1FqGR9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)