UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'occacQPmtttyKhf1xxAm2oCAm68etzovko4E185/nFg='
WHERE
key_id = '10d056e529fc3a0b51772b57d9b74a9fd3c95e26eea8a70ffa7fbd61cdcbe44b'
AND (
token = 'occacQPmtttyKhf1xxAm2oCAm68etzovko4E185/nFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)