UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'REFcboOdTSnA68KiCo583oOvBwQgeLGTdppVrYOPhnI='
WHERE
key_id = '48c30d5ffc09e936090195a702c4a813bf4932107329caf5b52d331dffd2cf34'
AND (
token = 'REFcboOdTSnA68KiCo583oOvBwQgeLGTdppVrYOPhnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)