UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XooGlhOTxFZuL1LVLUjg5sfTVJIz/EJjxj3q37SmPSc='
WHERE
key_id = '8a59e0e9e92b4b222cc1466d68ab996a99d62bb52f034c34a2b72d2e10d973a6'
AND (
token = 'XooGlhOTxFZuL1LVLUjg5sfTVJIz/EJjxj3q37SmPSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)