UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fnCwixb1HjrytiHD8SEULTwUeemGsvHwsXQoUuiaqc='
WHERE
key_id = 'a4f4f723f03e27a1fd927b9ac43625632110ecd58ce1a0f1d4b86033f5722c9b'
AND (
token = '1fnCwixb1HjrytiHD8SEULTwUeemGsvHwsXQoUuiaqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)