UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1t9ioIXnd8pFF9P/vwB92/ASw3dmzYJD0eXRsb6vws='
WHERE
key_id = 'd4a3d1adfde32475188577e7de6c27ec752063fc2bcaa4f6f7cee0d4a60ac459'
AND (
token = 'P1t9ioIXnd8pFF9P/vwB92/ASw3dmzYJD0eXRsb6vws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)