UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GqsHYVpY0T0tIjn46PVAV+YzWt+hvvkMIBI3PNpd2MA='
WHERE
key_id = 'a38c51140517059fe591f8b11a29698b9fe49d748281d8f799c3803d13c18f11'
AND (
token = 'GqsHYVpY0T0tIjn46PVAV+YzWt+hvvkMIBI3PNpd2MA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)