UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sdW30kSCtGRDrtexEmUQttvigu32JOmAJL0WU+vVHGU='
WHERE
key_id = '3bbad64c1294e8940f5ec514ec62c34ed0879a84f6d48580296e24271ada6c04'
AND (
token = 'sdW30kSCtGRDrtexEmUQttvigu32JOmAJL0WU+vVHGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)