UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2oFYxLAM6rdnspyc9UUvMnZHGQFtaLsFKjn4wh3bfyM='
WHERE
key_id = 'b1fade710aeb1544678e2dfba52bb8ac067fa3ad1b8a401b4a720b9c48320d7b'
AND (
token = '2oFYxLAM6rdnspyc9UUvMnZHGQFtaLsFKjn4wh3bfyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)