UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NWMbz6IGtL36fbCumqGyder5iBBSLaCqlzViwadgnLE='
WHERE
key_id = 'af309630c9e2e8b4530cf527230a0d50f4e40f32acb5b15834f2693094ca8901'
AND (
token = 'NWMbz6IGtL36fbCumqGyder5iBBSLaCqlzViwadgnLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)