UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6O2PYmc7emwnAlyMDDgJP+v4VTtibzhBOUv+mg0tGQ='
WHERE
key_id = '3167924d2dd6ed35917435ac3de8931a6cda2e770a8868f8d297ca60f167f3be'
AND (
token = 'L6O2PYmc7emwnAlyMDDgJP+v4VTtibzhBOUv+mg0tGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)