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