UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5GQVDRBgKYyjvHNvKR0EETVGQxl2QtjoHMRNSR93DQ0='
WHERE
key_id = '507780560115e89a6292b02bc05d4051c4e2f51cea9caed527efc2535282636d'
AND (
token = '5GQVDRBgKYyjvHNvKR0EETVGQxl2QtjoHMRNSR93DQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)