UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UP8iAvWeBqxP6/vHoXjyfm9zBlbOW3qFy1UdgcNDKSY='
WHERE
key_id = '6d9c3e59fa848ea01f539685cf69d23b0662d42f69779f7d2633d170a8a966f2'
AND (
token = 'UP8iAvWeBqxP6/vHoXjyfm9zBlbOW3qFy1UdgcNDKSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)