UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tKlSXDd4yFF+lrzrpZPaORCPijPErYgigRU28P6UyoU='
WHERE
key_id = 'dfc8543bae4c1755718251068b48a8ad0857254d207630155104b007c58c368a'
AND (
token = 'tKlSXDd4yFF+lrzrpZPaORCPijPErYgigRU28P6UyoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)