UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+DDNFdf+9ob/qNaolE470CacxCadE/E9D0nZwX6zV4='
WHERE
key_id = '865de7c3b9df11e8e83ec784e88205e7ce11a53e0b43ff5ecf7f601a2c934270'
AND (
token = 'p+DDNFdf+9ob/qNaolE470CacxCadE/E9D0nZwX6zV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)