UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bi7m2kwyihdSHBizrmGlsPHM8dM9NntWHdBQHSecJrs='
WHERE
key_id = '9eb23c7d841c44f26cf991364ec8e0689fd330e6894748cebcea791b9da33f70'
AND (
token = 'Bi7m2kwyihdSHBizrmGlsPHM8dM9NntWHdBQHSecJrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)