UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ntuY9tywDn0+csVHJYeHjCP+dSG7f2tdbLyquF9uTYo='
WHERE
key_id = '2ecc9f1be9d830b89154a05bc334c286065af87c3796ba2ab66ca911ce20b270'
AND (
token = 'ntuY9tywDn0+csVHJYeHjCP+dSG7f2tdbLyquF9uTYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)