UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gxa7e3BS8Qw+ORc0oeIk8yqU6pcmIiNdmJAg/qa2+W0='
WHERE
key_id = '22802d918ccf183fdce540691daae8e42978df77a7129a8ecd4e43a259fa1355'
AND (
token = 'Gxa7e3BS8Qw+ORc0oeIk8yqU6pcmIiNdmJAg/qa2+W0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)