UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDN1xkhwS3t/IdYvRGWf6d7kNGpQDzuA4Z46fvTarL8='
WHERE
key_id = '68e42986f74026fea81171b64e2910fa272313cf971173072de42f2a92a60f64'
AND (
token = 'ZDN1xkhwS3t/IdYvRGWf6d7kNGpQDzuA4Z46fvTarL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)