UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xspWIWZnnkTNzfrOldsKLHPC08P2c7THQvnnBQDbf4E='
WHERE
key_id = '118e59b281a2eeac95d2307d3920595b77de4f50118eba396240d6a6d5716c8c'
AND (
token = 'xspWIWZnnkTNzfrOldsKLHPC08P2c7THQvnnBQDbf4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)